home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Software of the Month Club (Business) 1998 January
/
Software of the Month Club - Business Shareware (Volume 245) (January 1998).iso
/
dos
/
biz
/
train
/
pack1.prg
/
TEMP2
/
DEHELP.MSG
< prev
next >
Wrap
Text File
|
1993-03-11
|
52KB
|
1,188 lines
298
#1 s 1:1-8 - 1:1-10
Type the Database Name and press RETURN.
#2 1:1-8
Type your User Name and press RETURN.
#3 1:1-8
Type your Password and press RETURN. The Password remains invisible.
#4 s 1:1-9 - 1:1-10
A new database will be created on your data drive.
#6 s 1:1-15 - 1:1-20
<HELP>
ALT-F1 HELP Provide help on current function.
<SELECTING FROM MENUS>
F1 MORE Scroll menus
ESC EXIT Exit menu
\U UP Previous menu item
\D DOWN Next menu item
Home HOME First menu item
End END Last menu item
PgUp PREV PAGE Previous menu page
PgDn NEXT PAGE Next menu page
\N RETURN Select highlighted item
<ENTERING DATA IN A FIELD>
F6 CLEAR FIELD Clear the current field
\L LEFT Delete previous character
\R RIGHT Next character in field
\S BACKSPACE Delete previous character
\N RETURN Next field
Ins INSERT Insert mode on/off
Del DELETE Delete current character
#10 2:2-13
Select {1} To define a new form.
{2} To view or modify a form or print a form definition.
{3} To define, view or modify, or delete relationships.
{4} To delete a form.
{5} To recreate the form's data and index files.
#11 2:2-14
Type the new Form Name and press RETURN.
Do not start the name with a number.
#12 s 2:2-93 - 2:2-94
Select the form to view or modify and press RETURN.
After viewing the form, press ESC EXIT.
After modifying the form, press F2 SAVE.
#13 2:2-131
Select the form that you want to delete, and press RETURN.
All the records in the form will also be deleted.
#14 2:2-105
Select {No} to save under the same name.
Select {Yes} to save under another name. Specify the new name
and press RETURN.
#16 2:2-106
Select {Yes} to transfer records from the current form to the new form.
#17 s 2:2-101 - 2:2-104
Select {Yes} if you have reorganized the choices. Select {No} if you
have only added choices, or changed choice descriptions.
#18 s 2:2-132 - 2:2-133
Select the form that you want to reorganize, and press RETURN.
#19 s 2:2-17 - 2:2-34
F2 Save the form.
ESC Exit without saving.
F4 Display Command menus.
<To Move Cursor>
\L \R \U \D One space in the indicated direction.
Ctrl \L Ctrl \R First or last position in line.
Home or End First column in first or last line.
\T \B Next or previous tab position.
\R First column in next line.
PgUp or PgDn Previous or next page.
<To Edit Text>
Ins Turn Insert mode on or off.
Del Delete a character.
F3 Cut a block of text.
F5 Copy a block of text.
F6 Paste the copied or cut block.
F7 F8 Delete a line. Insert a line.
Alt-F10 Draw borders and use the Extended Character set.
<To Define a Field>
Type the Field Name, position the cursor, press F10.
#50 1:2-11
Select a form in which to enter, modify, view, or delete records.
From this form, you can access related forms, and define
Quick Reports based on this form.
#51 s 2:2-15 - 2:2-34
<To Move Cursor>
\L \R One space left or right. \U \D Field above or below.
Home End First or last field. \T \B Next or previous field.
\R Next Field. PgUp PgDn Previous or next page.
<To Edit Text>
Ins Turn Insert mode on/off. Del Delete current character.
<Record Processing>
SH-F1 Display Table View. F6 Clear field.
F2 Save a record. SH-F6 Default for field.
SH-F2 Save Default record. F7 Delete current record.
F3 View next/selected record. F8 Modify current record.
SH-F3 View previous record. F9 Quick Reports menu.
ALT-F3 Continue selected view. SH-F9 Print current record.
CTRL-F3 View by record number. ALT-F9 Auto Derivation off/on.
F4 Display Command menus. CTRL-F9 Rederive all fields.
F5 Clear all fields. F10 Go to a related form.
SH-F5 Read Default record. ALT-F10 Ad-hoc Multiform.
ALT-F5 Enter UNCHECKED mode. CTRL-F10 Lookup related form.
CTRL-F5 Undo record changes. ESC Exit.
#52 s 1:3-2 - 1:3-6
<Purpose> <Step> <Comments>
{Define Report} 2. Start New Report Required if a report is in memory.
3. Select Records Optional, Default: All records.
4. Select Fields Optional, Default: All fields.
5. Define Format Optional, Default: Columnar.
6. Define Print Style Optional, Default: Screen.
10. Print Report Defin. As desired.
1. Run a Report As desired.
7. Save a Report As desired.
{Modify Report} 8. Load a Report Select an existing report.
3, 4, 5, 6, or 10 Select desired steps in any order.
1. Run report As desired.
7. Save Report As desired.
May save under a new name.
{Run a Report} 2. Start New Report Required if a report is in memory.
1. Run Report Select the report to run.
#53 s 1:2-42 - 1:2-44
Select a relationship to view.
The first related record is displayed.
If no related record is found, the related fields are copied.
Press ALT-F3 to see other related records.
Enter, modify, delete, view or print records.
View forms related to this form.
#54 s 1:3-17, 1:3-22
Select a relationship to include in the report.
#55 s 1:3-11 - 1:3-18
Move the cursor to each field to be used for record selection.
Type the record selection criteria:
{ConstantValue} James* James Ivory "James*" 23 Male
{Multiple Values} "James*" or "Bill*" Male or Female
{Ranges} =^> 23 ^>= 23 and ^<= 100 between 23 to 100
{Comprehensive} (^> Rate * Hours or ^< 20000) and ^< lookup DEPT Salary
#56 s 1:3-19 - 1:3-23
{Move the cursor} to each field to be listed in the order it is to be
listed. {Press the Spacebar} to mark the field with its relative
order in the list. You may also type the relative order. Then
specify the list options:
{To sort or group on a field}, specify one of:
Order - Sort in order
Reverse - Sort in reverse
Group - Group by field
{To obtain field statistics}, specify one or more of:
Count - Count of records processed
Sum - Total
Mean - Average
Min - Lowest
Max - Highest
Std.Dev. - Standard Deviation
Std.Err. - Standard Error
Variance - Variance
#60 s 3:2-3 - 3:2-28
<Purpose> <Step> <Comments>
{Define Procedure} 2. Start New Procedure Required if procedure in memory.
3. Data-entry Form Optional, run-time variables.
Transaction input.
4. Define Query Required.
5. Define Format Optional, Default: Columnar.
6. Define Print Style Optional, Default: Screen.
10. Print Procedure Print Procedure Definition.
1. Run Procedure As desired.
7. Save Procedure As desired.
{Modify Procedure} 8. Load Procedure Select an existing procedure.
3, 4, 5, 6, or 10 Select desired steps in any order.
1. Run Procedure As desired.
7. Save Procedure As desired.
May save under new name.
{Run Procedure} 2. Start New Procedure Required if procedure in memory.
1. Run Procedure Select the procedure to run.
#62 s 3:2-7 - 3:2-13
The Data-entry form is used to enter information for the procedure at
the time the procedure is run. The information entered may be used
anywhere in the query: for record selection criteria, in calculations, or
for listing in the report output.
#63 3:2-8
Answer {Yes} if you want to run the procedure repeatedly without
returning to the menu.
With this option, the procedure can be used for transaction processing.
The Data-entry form becomes the transaction input form. The data entered
in the transaction can be posted to any number of files via DQL.
It can also be used to create alternate views of the data, where the
Data-entry form becomes a subset of information in one form or a superset
of information in multiple forms.
#64 3:2-13
Answer {Yes} if you want to delete the Data-entry form currently defined
for the procedure.
#65 3:2-23
Answer {Yes} if you want to create another procedure without overwriting
the current procedure.
#66 3:2-23
Enter the name of the procedure and press RETURN.
Do not start it with a number.
#67 3:2-24
Select the procedure to load and press RETURN.
#68 3:2-26
Select the procedure to delete and press RETURN.
#69 3:2-5
Select the procedure to run and press RETURN.
#70 3:5-4
Select {Yes} to keep the format you have already designed.
Select {No} for a new predefined format, or to design a new custom format.
#71 s 3:5-5, 3:5-8 - 3:5-26
<Report Formats>
Select {Columnar} to get a tabular report with one line per record.
{Field per Line} to place every field on a new line.
{Record Entry} to use the record entry form.
{Template} to use a predefined template form.
{GrafTalk} to use the report data to create a GrafTalk chart.
{Custom} to design your own format.
{Export} to export to other programs.
{Mailing Labels} to print on "multi-across" labels.
#72 s 3:5-27 - 3:5-39
<Export Formats>
Select the format that is accepted by the destination program.
{Mail-merge} exports data to Wordstar and other programs.
{MultiMate} exports data to MultiMate.
{WordPerfect} exports data to WordPerfect.
{GrafTalk} exports data to DataEase GrafTalk.
{Lotus 1-2-3} exports data to Lotus 1-2-3/Symphony.
{Variable Length} exports data to Mainframes and custom programs.
{Fixed Length} exports data to Mainframes and custom programs.
{DIF} exports data to various spreadsheet and graphics programs.
#73 s 3:5-27, 3:5-39
Select {Yes} if you want the Field Names to be exported.
#74 s 3:5-12 - 3:5-13
Select {Yes} if you want to create a Group Header and Trailer for each
level of grouping specified in the query.
#75 3:6-47
Select {1: copy all from} to copy all fields with matching names from a
database form or the Data-entry form.
#76 s 3:5-42 - 3:5-57, 3:5-65 - 3:5-68
<Report Format Command Lines>
{REQUIRED}
.items Items area repeated for each record.
.end Report End Area printed at the end of a report.
{PAGE CONTROL}
.page Forces a new page.
.header (N) Header at the top of each page (starting at [N]).
.footer (N) Footer at the bottom of each page (starting at [N]).
{GROUP FORMATS}
.group header At the start of each group.
.group trailer At the end of each group. Place group totals here.
{OTHER}
.items nosplit Output from each record will appear on the same page.
across M wide N The following values will be printed [M] times across,
and each will be [N] spaces wide.
printer control [@c1] to [@c4] select CPI 1 to 4 from print definition
[@l1] to [@l4] select LPI 1 to 4 from print definition
special effects [@b,@nb; @i,@ni; @u,@nu; @s1,@ns1; @s2,@ns2]
bold 4italic u'line special1 - special9
Alt-F10 Extended ASCII output characters, including highlights.
#77 s 3:5-40 - 5-57
Select the list field to be placed here.
#78 s 3:5-40 - 3:5-57
Select the list item or statistic to be placed here.
Statistics may not be placed in Group Header or Report Header.
Statistics (sum, max, min, count) may be placed in the Items Area, and in
Page Headers and Footers.
Group Statistics may only be placed in Group Trailers.
#79 3:5-62
For Fixed point or Integer fields, select {Yes} to suppress commas.
#80 3:5-62
For Fixed point fields, select {Yes} to suppress the decimal.
#81 3:5-63
Select {Yes} to remove space at the start or end of field, to combine
the field with the adjoining text.
#85 s 3:2-15 - 3:2-21
<QUERY PROCEDURES>
{INTERACTIVE MODE} [(Starting mode when you define a query)]
Multiple Choice Questions
Select or Type Type Choice Number or the Entire Phrase.
Skip Question Press TAB, or 0.
Type Out Questions
Type Type the answer and press Spacebar. Press TAB to skip.
Typing Ahead Type ahead symbols and punctuation, not numbers.
Making changes Move the cursor and edit.
Go into Edit Mode Move the cursor up or to the left.
{QUERY LEVELS}: [LOW] Level should generally be used to save time.
Change to [HIGH] Level by using [F9 LEVEL] when you need to enter,
modify, or delete records, or access a DQL Procedural command,
Control command, or data manipulation function.
{EDIT MODE} [(Starting mode when you modify a query)]
Editing Type and use all cursor and editing functions.
End the query Press F2 SAVE.
Go to Interactive Position cursor, and press F1 INTERACTIVE.
#86 s 3:6-73 - 6-75, 3:6-148
Select the name of the Primary form.
#87 s 3:6-165, 3:6-196
Select {1: with} to select records from the form. To report on all
records, press TAB.
#88 s 3:4-1, 3:6-46, 3:6-150
DQL Advanced Processing is performed by two types of procedures.
A {PROCESSING PROCEDURE} lets you list, enter, delete, or modify records,
and create screen, disk, or printed output. A Processing procedure may
include Processing commands and/or Procedural commands, but may not
include Control commands. A Low Level Processing procedure can only
list records. A High Level Processing procedure can also enter, modify,
and/or delete records.
A {CONTROL PROCEDURE} lets you link procedures together with or without
conditional processing actions specified by Procedural commands.
A Control procedure may include Procedural commands and/or Control commands,
but may not include Processing commands. A Control procedure can only be
defined in High Level.
#89 s 3:6-91 - 3:6-94
Select {in order} to sort records in ascending order by this item.
{in reverse} to sort records in descending order by this item.
{in groups} to process records with same value together.
{in groups with group-totals} to process records in groups and
generate group statistics.
Advantages of {in groups}:
The item value is listed only once per group.
Each group can be formatted using group headers and trailers.
#90 s 3:6-101, 3:6-119 - 3:6-120, 3:6-126, 3:6-174 - 3:6-176, 3:6-189
Select one or more Statistical Operators:
Select {item} to list the item itself in the report output.
{sum} for the total of the values in the specified field.
{mean} for the average value.
{max} for the highest value.
{min} for the lowest value.
{variance} for the Variance among the values.
{std.dev.} for the Standard Deviation.
{std.err.} for the Standard Error.
#91 s 3:6-101, 3:6-119 - 3:6-120, 3:6-126
Select one or more Statistical Operators:
Select {item} to list the item itself in the report output.
{mean} for the average value.
{max} for the highest value.
{min} for the lowest value.
#92 s 3:6-101, 3:6-119 - 3:6-120, 3:6-126
Select {item} to list the item itself in the report output.
{max} for the highest value.
{min} for the lowest value.
#93 s 3:6-43, 3:6-50, 3:6-102, 3:6-142
Select one or more Condition Statistical Operators:
{item} returns "YES" if condition is true; "NO" if false.
{count} counts the records that satisfy the condition.
{percent} calculates percent of records that satisfy the condition.
#94 s 3:6-43 - 3:6-44, 3:6-176
Select {1} if you want to include statistics for this item.
#95 s 3:6-158
Select {1} to specify a relationship (list records in a related form).
#96 s 3:6-132 - 3:6-133
Select {0} to modify records in the Primary form; {1} to modify records
in another form.
#97 3:6-61
Select {0} to delete records in the Primary form; {1} to delete records
in another form.
#98 3:6-66
Select the form into which records will be entered.
#99 3:6-110
{list records in} FORMNAME ^| RELATIONSHIP ^[{named} "UNIQUE RELATIONSHIP
NAME"^] ^[{with}(selection criteria)^]
List fields in selected records in the Primary form or a related form.
Separate each list item with a semi-colon (;).
After the last item type a period.
A list item may be any type of value: a field name, a field in a related
form, a constant value, a variable, or a formula. For each list item,
optionally specify ordering or grouping, and statistics.
#100 s 3:6-132 - 3:6-133
{modify records in} FORMNAME ^| RELATIONSHIP ^[{named} "UNIQUE RELATIONSHIP
NAME"^] ^[{with}(selection criteria)^]
FIELDNAME := MODIFIED VALUE
Modify fields in selected records in the Primary form or a related form.
Select the field(s) to be modified.
Specify the modified value to be given to each field.
#101 3:6-61
{delete records in} FORMNAME ^| RELATIONSHIP ^[{named} "UNIQUE RELATIONSHIP
NAME"^] ^[{with}(selection criteria)^]
Delete selected records in the Primary form or a related form.
#102 3:6-66
{enter a record in} FORMNAME
Enter a record in the specified form.
Specify the target form.
Specify all the fields in the record to be entered.
Specify the value to be given to each field.
#103 s 3:6-85 - 3:6-86
{if} CONDITION {then} ACTIONS1 ^[{else} ACTIONS2 ^] {end}
If condition is true, perform actions1, else perform optional actions2.
Specify the condition for the {if} statement.
Specify the actions to be performed if the condition is true.
Insert an optional {else} clause, and specify the actions to be executed
if the condition is false.
Use an {end} command to terminate the {if} statement.
#104 s 3:6-194 - 6-195
{while} CONDITION {do} ACTIONS {end}
While condition is true, perform all specified actions.
Specify the condition for the {while} statement.
Specify the actions to be executed while the condition is true.
Use an {end} command to terminate the {while} statement.
#105 s 3:6-73 - 3:6-76
{for} FORMNAME ^| RELATIONSHIP ^[{named} "UNIQUE RELATIONSHIP NAME"^]
^[{with}(selection criteria)^] ACTIONS {end}
Perform all the specified actions for each selected record.
Specify the form or relationship that contains the records to be processed.
Specify the record selection criteria.
Specify all the actions to be performed for each selected record.
Use an {end} command to terminate the {for} statement.
#106 s 3:6-59 - 3:6-60
{define} {global} ^| {temp} "VARIABLE NAME" TYPE ^[LENGTH^] .
Define a variable with the specified name, status, type, and length.
Select the status of the variable: global or temporary.
Type the name of the variable enclosed in quotes.
Specify the variable's type.
Optionally, specify the variable's length.
Use a period to end the {define} statement.
#107 3:6-192
Select {1) to use a global variable.
Select {2) to use a temporary variable.
#108 3:6-28
{assign} {global} ^| {temp} VARIABLE NAME := ASSIGNED VALUE .
Assign a value to the specified variable.
Select the variable to the assigned.
Type the value to be assigned to the variable.
Use a period to end the {assign} statement.
#109 s 3:6-45, 3:6-77, 3:6-105, 3:6-136, 3:6-192
A value can be any of the following:
Field Name (field from the Primary form or a related form)
Constant (text constants are enclosed in quotes)
Formula (see operations, below)
Function
Variable
Operations allowed are:
Arithmetic: + - * /
Logical and or
Comparison = ^> ^< ^>= ^<= between not
#110 s 3:6-25, 3:6-137, 3:6-165
Select {0: NONE} to end selection criteria.
{1: and} if both conditions must be true.
{2: or} if either condition may be true.
#111 s 3:6-25, 3:6-137, 3:6-165
Select {0: NONE} if no more conditions are to be defined.
{1: and} to define one more condition that must be true.
{(} to define a set of conditions containing {or}.
#112 s 3:6-25, 3:6-137, 3:6-165
Select {0: NONE} if no more conditions are to be defined.
{1: or} to define one more condition that may be true.
{(} to define a set of conditions containing {and}.
#113 s 3:6-15 - 3:6-17, 3:6-42
Select {1: =} for equal to
{2: ^>} for greater than
{3: ^<} for less than
{4: ^>=} for greater than or equal to
{5: ^<=} for less than or equal to
{6: between} for a range
{7: not} to reverse the meaning of the following operator
#114 s 3:6-4 - 3:6-5
The following arithmetic operators are provided:
{+} Plus
{-} Minus
{*} Multiply
{/} Divide
#115 3:6-10
{(} (parentheses) lets you specify the order of evaluation, as well as
combine {and} and {or} in selection criteria or conditions.
#117 3:6-108
Select a Field Name. To skip press {0} or {TAB}.
#118 3:6-33
An unspecified field value is represented by the keyword {blank}. It is
used to assign an unspecified value to a field, to check if a field value
has been specified, and/or to output a {blank} field.
#119 3:6-45
Specify a Constant value typed as follows:
{FIELD TYPE} {COMMENTS} {EXAMPLES}
Text Enclose text in double quotes "James"
Num. String Do not type the format characters 42035551212
Number Do not type commas 10012.15 -2456
Date Use slashes in a Date value 12/31/99
Time Use colons in a Time value 23:59:59
Yes or No Select value from the menu Yes No
Choice Select value from the menu Male Female
The keyword {blank} can be used as an unspecified value for any Field Type.
#120 3:6-158
A relationship lets you select records in a related form based on a
specified field value as summarized below:
{Operator} {Returns}
all Specified field value from EACH related record.
(This operator can only be used as a list item).
any Specified field value from the FIRST related record.
count of Count of records in set of related records.
highest of Highest specified value from set of related records.
lowest of Lowest specified value from set of related records.
sum of Sum of specified value from set of related records.
mean of Avg. of specified value from set of related records.
#121 s 3:6-20 - 3:6-21, 3:6-158
Once a relationship has been defined in the query, you need not specify
it again. Select one of the relationships that you have already defined
in the query. Press TAB to define a new relationship.
#122 s 3:6-20 - 3:6-21, 3:6-158
These forms have a predefined relationship to the last form specified
in the query. The criteria for these relationships have already been
defined, but you may add to the criteria by creating an ad-hoc relationship.
Select a form or Press TAB to define an ad-hoc relationship.
#123 s 3:6-20 - 3:6-21, 3:6-158
Select a form to define a new relationship with. You may then optionally
specify record selection criteria for the relationship.
#124 s 3:6-20 - 3:6-21, 3:6-132 - 3:6-133, 3:6-158
If you define more than one relationship with the same form using different
record selection criteria, you must provide a unique name for each
relationship. To provide a unique name, select {1: named}, then type the
name in quotes.
#125 s 3:6-20 - 3:6-21, 3:6-132 - 3:6-133, 3:6-158
You may optionally define criteria for the relationship. If the
relationship is predefined, these criteria will be added to those
already defined.
#126 3:6-77
[IF FUNCTION]
{if}(CONDITION, TRUE VALUE, FALSE VALUE)
[DATE FUNCTIONS]
{month}(DATE) {day}(DATE) {year}(DATE)
{weekday}(DATE) {yearday}(DATE) {yearweek}(DATE)
{date}(MONTH,DAY,YEAR) {julian}(DATE)
[SPELL FUNCTIONS]
{spellmonth}(MONTH) {spellweekday}(DAY OF THE WEEK)
{spelldate}(DATE) {spellnumber}(NUMBER) {spellcurrency}(NUMBER)
[TIME FUNCTIONS]
{hour}(TIME) {minutes}(TIME)
{seconds}(TIME) {timeampm}(TIME) {ampm}(TIME)
[TEXT FUNCTIONS]
{firstc}(TEXT, # Chars) {firstw}(TEXT, # Words)
{lastc}(TEXT, # Chars) {lastw}(TEXT, # Words)
{midc}(TEXT, StartChar, # Chars) {midw}(TEXT, StartWord, # Words)
{jointext}(TEXT1, TEXT2) {length}(TEXT)
{lastfirst}(NAME) {firstlast}(NAME)
{upper}(TEXT) {proper} (TEXT) {lower}(TEXT) {textpos} (TEXT1,TEXT2)
#127 s 3:6-77, 3:6-78, 3:6-100, 3:6-141, 3:6-143, 3:6-151
[FINANCIAL FUNCTIONS]
{presentvalue}(futurevalue, installment, rate, periods)
{futurevalue}(presentvalue, installment, rate, periods)
{installment}(presentvalue, futurevalue, rate, periods)
{rate}(presentvalue, futurevalue, installment, periods)
{periods}(presentvalue, futurevalue, installment, rate)
[MATH/SCIENTIFIC FUNCTIONS]
{exp}(NUMBER) {log}(NUMBER) {log10}(NUMBER) {power}(NUMBER) {sqrt}(NUMBER)
{abs}(NUMBER) {ceil}(NUMBER) {floor}(NUMBER) {mod}(NUMBER,BASE NUMBER)
{random}()
[TRIGONOMETRIC FUNCTIONS]
{sin}(ANGLE IN RADIANS) {cos}(ANGLE IN RADIANS) {tan}(ANGLE IN RADIANS)
{asin}(SINE VALUE) {acos}(COSINE VALUE) {atan}(TANGENT VALUE)
{sinh}(ARGUMENT) {cosh}(ARGUMENT) {tanh}(ARGUMENT)
#128 s 3:6-52, 3:6-54
Select {0: NONE} to skip these options.
{1: current} for current date, time, page number, item number,
user name, user level, computer name, or status.
{2: data-entry} for a field from a Data-entry form, if defined.
#130 2:5-10
Type the name of the source file (including drive and directory) that
contains the data to be imported into the specified destination form.
#131 2:5-10
Select the DataEase form into which the data will be imported.
#132 s 2:5-10 - 2:5-11
Select the format of the source data file.
#133 2:5-17
Select {Yes} if the source DataEase form is identical to the destination
DataEase form. Otherwise, select {No}.
#134 2:5-17
Type the name of the source DataEase form definition file. You need not
specify the file extension (DBA).
#135 2:5-22
Type the field separator character and press RETURN. If the field
separator is the new line character, press RETURN.
#136 2:5-22
Type the record separator character and press RETURN. If the record
separator is the new line character, press RETURN.
#137 2:5-28
If you select {Yes}, DataEase will insert a decimal in all Fixed Point
fields in the import file that do not already have a decimal point. If
you answer {No}, DataEase does not insert decimals although it does import
decimal points that exist in the source file.
#138 2:5-13
DataEase matches the records being imported to the existing records
in the destination form based on the values in the Unique fields.
Select {1. ADD NON-MATCHING} if importing only new records.
{2. UPDATE MATCHING} if updating existing records.
{3. ADD OR UPDATE} if importing new and updating existing records.
{4. DO NOT MATCH} saves time if you are importing only new records,
and you are sure the import file doesn't contain duplicate records.
#139 s 2:5-19, 2:5-23
DataEase can match fields in the source file to the fields in the
destination form either by Field Order or by Field Name.
Select {1. BY FIELD ORDER} if the order of the fields is identical in
the source file and the destination form.
Select {2. BY FIELD NAME}, providing there are corresponding Field Names
in both files.
For Lotus 1-2-3, DIF, Mail-merge, and Variable Length files, the first
record imported must contain the source Field Names.
For dBASE and DataEase files, the Field Names are already present in the
respective file definitions and need not be included as records.
#140 2:5-33
Type the name of the form to be installed.
#141 2:5-34
Type the filename of the source Form Definition file. This file has
an extension of DBA (which you need not type). Specify the full PATH,
including the drive if it is other than the current data drive.
#142 2:5-34
If you do not want to install data in the form, press RETURN.
Otherwise, type the filename of the source Data file. This file has
an extension of DBM (which you need not type). Specify the full PATH,
including the drive if it is other than the current data drive.
#143 s 2:5-35 - 2:5-36
Type the name of the DQL Procedure (or Quick Report) to be installed.
Do not start it with a number.
#144 s 2:5-35 - 2:5-36
Type the filename of the Procedure Definition file. This file has
an extension of DBR (which you need not type). Specify the full PATH,
including the drive if it is other than the current data drive.
#145 s 2:5-35 - 2:5-36
Select {Yes} if the procedure has an associated Data-entry form (.DBF file
extension). The Data-entry form file must be present on the same drive as
the Procedure Definition file.
#146 2:5-41
Select or type the filename of the Import Specification file.
This file has an extension of DBI (which you need not type). Specify
the full PATH, including the drive if it is other than the current
data drive.
#147 2:5-40
Type the name of the Installation Command file. This file has an extension
of DIN (which you need not type). Specify the full PATH, including the
drive if it is other than the current data drive.
#148
Data transfer will use the server batch facility.
#150 1:4-15
Specify the drive and directory for the Backup or Restore.
#151 1:4-15
If an error occurs during Backup or Restore, select {1: Ignore and Continue}
or {2: Cancel} if you are not going to be present to take action. Otherwise
select option {3: Decide upon Error}.
#152 s 1:4-4 - 1:4-13
Select {1. Forms} to get a list of forms and the corresponding files.
{2. Procedures} to get a list of Quick Reports and DQL Procedures.
{3. Import Specifications} to get a list of Imports.
#160 2:2-18
<More Help> displays a help message for the current function.
#161 2:2-26
<Borders & Ext Char Set> is used to draw borders or access the ASCII
extended character set.
#162 s 2:2-20 - 2:2-21
<Copy> copies a block of text and fields. Select <Copy> then select
None, Block, Form, or Dictionary field to specify the type of copy
you want to make.
#163 2:2-19
<Cut> moves or deletes fields and/or text. Select <Cut>, move the
cursor to the first character you don't want to cut, and
select <Cut> again.
#164 2:2-21
<Paste> places cut (F3 CUT) or copied (F5 COPY) text and/or fields
onto the form.
#165 2:2-22
<Ins Line> inserts a blank line at the current cursor position and
moves the current cursor line and all following lines down one line.
#166 2:2-22
<Del Line> removes or erases the line on which the cursor rests.
#167 s 2:2-84 - 2:2-85
<Show Colors> displays the form as it will appear in Record Entry.
You can only use this option to view the form.
#168 s 2:2-84 - 2:2-85
<Underline> marks the beginning of a block that you want to underline
when it is printed using Record Entry format. Text marked as
underlined displays in the Regular Field color in Record Entry.
#169 s 2:2-84 - 2:2-85
<Bold> marks the beginning of a block that you want to print
in boldface. Text marked as bold displays in the Highlight 1 color
in Record Entry.
#170 s 2:2-84 - 2:2-85
<Italics> marks the beginning of a block that you want to print in
italics. Text marked as italic displays in the Highlight 2 color
in Record Entry.
#171 s 2:2-84 - 2:2-85
<CPI 2> marks the beginning of a block that you want to print using
a different characters per inch setting. Text marked as CPI 2
displays in the Title Area color in Record Entry.
#172 s 2:2-84 - 2:2-85
<CPI 3> marks the beginning of a block that you want to print using
a different characters per inch setting. Text marked as CPI 3
displays in the Mode Area color in Record Entry.
#173 s 2:2-84 - 2:2-85
<CPI 4> marks the beginning of a block that you want to print using
a different characters per inch setting. Text marked as CPI 4
displays in the Message Area color in Record Entry.
#174 s 2:2-84 - 2:2-85
<LPI 2> marks the beginning of a block that you want to print using
a different lines per inch setting. A block marked as LPI 2 displays
in the Prompt Line color in Record Entry.
#175 s 2:2-84 - 2:2-85
<LPI 3> marks the beginning of a block that you want to print using
a different lines per inch setting. A block marked as LPI 3 displays
in the Menu Highlight color in Record Entry.
#176 s 2:2-84 - 2:2-85
<LPI 4> marks the beginning of a block that you want to print using
a different lines per inch setting. A block marked as LPI 4 displays
in the Key Names color in Record Entry.
#177 s 2:2-84 - 2:2-85
<End Highlight> marks the end of a block that you have given a
specific highlight attribute.
#178 1:2-25
<Multiview> accesses related forms. Once the related form is
displayed you can view, enter, modify, or delete records.
#179 1:2-21
<Recalculate> recalculates the values of all the fields defined
with Derivation Formulas.
#180 1:2-21
<Suspend Calc> turns off automatic calculation of all the fields
defined with Derivation Formulas.
#181
<Exit> returns you to the previous menu.
#182 2:2-17
<Exit & Save> saves the form on the screen as a new form, or saves
the changes made to an existing form, and returns you to the Form
Definition menu.
#183 2:2-18
<Exit & Abandon> abandons the form, or changes made to an existing
form and returns you to the Form Definition menu.
#184 2:2-23
<Field> creates a record entry field beginning at the current cursor
position. You can view, modify, or delete an existing field
definition by moving the cursor into the field and selecting <Field>.
#185 s 2:2-24 - 2:2-25
<Form Properties> displays the Form Properties screen. Use this
screen to define security levels and help messages for the form,
encrypt records, and override the default Record Entry configuration.
#187 s 2:2-27 - 2:2-31
<Define Subform> displays the Subform Definition screen.
This screen is used to define Multiforms.
#188 2:2-32
<Print> prints the form definition.
#189 3:5-64
<Exit & Save> saves the format (in the computer's memory)
and returns you to the Quick Reports or DQL menu.
#190 1:2-18
<Exit & Abandon> returns you to the Quick Reports or DQL menu
without saving the format.
#191 s 3:5-60 - 3:5-63
<Field> defines or modifies a field in the format.
#193 s 3:2-27 - 3:2-28
<Print> prints the format.
#194 3:2-12
<Exit & Save> saves the Data-entry form (in the computer's memory)
and returns you to the DQL menu.
#195 1:2-18
<Exit & Abandon> returns you to the DQL menu without saving the
Data-entry form.
#196 3:2-9
<Field> defines or modifies a field on the Data-entry form.
#197 s 3:2-27 - 3:2-28
<Print> prints the Data-entry form definition.
#198 s 2:2-64, 2:2-72, 2:2-75
<Exit & Save> saves the Derivation Formula, Upper/Lower Limit
formula, or field help message and returns you to the Field
Definition screen.
#199 s 2:2-64, 2:2-72, 2:2-75
<Exit & Abandon> abandons any changes made to the Derivation Formula,
Upper/Lower Limit formula, or field help message and returns you to
the Field Definition screen.
#200 1:2-18
<Exit> exits Record Entry for this form and returns you to the
Record Entry menu.
#202 1:2-19 - 1:2-20
<Save> saves the record on the screen.
#203 s 1:2-19 - 1:2-20
<Modify> modifies the record on the screen.
#204 s 1:2-19 - 1:2-20
<Delete> deletes the record on the screen.
#205 s 1:2-19 - 1:2-20
<Clear Form> clears the form on the screen.
#206 s 1:2-19 - 1:2-20
<Clear Field> clears the field in which the cursor rests.
#207 s 1:2-19 - 1:2-20
<Del Long:Text line> deletes the line of the long:text field in which
the cursor rests.
#208 s 1:2-19 - 1:2-20
<Ins Long:Text line> inserts a line in a long:text field above the
line in which the cursor rests.
#209 s 1:2-19 - 1:2-20
<Undo Record> abandons the changes made to the record on the screen.
#210 1:2-21
<Print> prints a copy of the record currently on the screen.
#211 1:2-22
<Enter Search Criteria> clears the form, turns off all the
field derivations, and allows search values to be entered in Prevent
Data-entry fields.
#212 1:2-23
<Continue Search for Criteria> displays the next record that meets
the specified search criteria.
#213 1:2-22
<Begin Search for Criteria> begins a record search.
#214 1:2-22
<Next Consecutive Record> displays the next consecutive record in
the file.
#215 1:2-23
<Previous Consecutive Record> displays the previous record in the
file.
#216 1:2-23
<Go to Record Number> displays a specific record by record number.
#217 1:2-24
<Table View> displays a Table View of the records in the file.
Enter search criteria and select <Table View> to display a table
of matching records.
#218 1:2-25
<Multi-Form> creates an Ad-hoc Multiform.
#219 1:2-25
<Lookup> opens a window into a related form where you can look up
a value and bring it back into the Primary form.
#220 1:2-25
<Exit> exits a related form and returns you to the previous form.
#221 1:2-26
<Quick Report> displays the Quick Reports menu.
#222 1:2-27
<Default Field> retrieves the default value (saved on the Default
Record) for the field in which the cursor rests.
#223 1:2-27
<Default Form> retrieves the Default Record.
#224 1:2-27
<Save Default> saves the record on the screen (or in which the cursor
rests) as the Default Record.
#225 1:2-27
<Delete Default> deletes the default record.
#226 1:2-77
<Allow All Record Access> removes all locks placed on the record that
you are currently viewing.
#227 1:2-77
<Allow Read Record Access> only allows other users to view the record
you are viewing.
#228 1:2-77
<Allow No Record Access> prevents other users from accessing the
record that you are viewing.
#230 1:2-78
<Refresh> reads the record from disk and displays it on the screen.
#231 1:2-78
<Continuous Refresh> automatically refreshes the record on the
screen every few seconds.
#232 1:2-18
<Exit> exits Record Entry for this form and returns you to the
Record Entry menu.
#234 1:2-29
<Save Changes> saves all the changes/modifications made to the table.
#235 1:2-29
<Undo Changes> abandons all the changes made to the table that have
not scrolled off the screen and have not been saved by pressing
F2 SAVE.
#236 1:2-29
<Delete Record> deletes the record on the line in which the
cursor rests.
#237 1:2-29
<Clear Field> clears the field in which the cursor rests.
#238 1:2-29
<Enter New Records> scrolls some records off the screen and displays
some blank lines into which you can enter new records.
#239 1:2-21
<Print> prints the table on the screen.
#240 1:2-30
<Form View> toggles from Table View to Form View.
#241 1:2-31
<Lookup> opens a window into a related form where you can look up a
value and bring it back into the Primary form.
#242 1:2-31
<Exit> exits a related form and returns to the previous form.
#247 1:2-79
<Allow All File Access> removes any locks placed on the form you
are viewing.
#248 1:2-79
<Allow Read File Access> only allows other users to view the records
in the form you are viewing.
#249 1:2-79
<Allow No File Access> prevents other users from accessing the form
you are viewing.
#250 1:2-79
<Refresh> reads the records listed in the table on the screen and
redisplays each record as it appears on the disk.
#251 1:2-78
<Continuous Refresh> automatically refreshes the records on the
screen every few seconds.
#252 3:2-22
<Exit & Save> saves the query (in the computer's memory)
and returns you to the DQL menu.
#253 3:2-22
<Exit & Abandon> returns you to the DQL menu without saving the query.
#254 3:2-15
<Interactive Mode> switches from Edit Mode to Interactive Mode.
#255 s 3:2-18, 3:2-21
<Change Level> changes levels (from Low Level to High Level or
High Level to Low Level).
#256 s 3:6-139 - 3:6-143
<Field> displays the Report Field Definition screen and lets you
define a field in the query. This option is used with the
DQL Output command.
#257 3:2-22
<Exit & Save> saves the query (in the computer's memory)
and returns you to the DQL menu.
#258 3:2-22
<Exit & Abandon> returns you to the DQL menu without saving the query.
#259 3:2-20
<Edit Mode> switches from Interactive Mode to Edit Mode.
#260 s 3:2-18, 3:2-21
<Change Level> changes levels (from Low Level to High Level or
High Level to Low Level).
#261 3:2-16
<Skip Menu> bypasses the current Interactive menu options.
#262 1:3-9
<Exit> exits Define/Modify Record Selection or Define/Modify List
Fields and returns you to the Quick Reports menu.
#263 1:3-9
<Save> saves the record selection criteria or list field definition
for the report and returns you to the Quick Reports menu.
#264 1:3-9
<Clear Form> removes the selection criteria or list field numbers
from all the fields on the form.
#265 1:3-9
<Clear Field> removes the selection criteria or list field numbers
from the current field.
#266 1:3-9
<Print> prints the record selection criteria or list field definition
specified for the report.
#267 s 1:3-17, 1:3-22
<Multiview> displays a related form. Once the related form is
displayed you can specify record selection criteria or select fields
to list from the related form.
#268 s 1:3-17, 1:3-22
<Exit Multiview> exits a related form and returns you to the previous
form.
#269 3:2-10
<Enter & Continue Procedure> saves the data entered on the Data-entry
form and continues running the procedure.
#270 1:2-18
<Exit & Abandon> returns you to the DQL menu without saving the data
entered on the Data-entry form.
#271 s 1:2-19, 3:2-9
<Clear Form> clears all the data on the Data-entry form.
#272 s 1:2-19, 3:2-9
<Clear Field> clears the data in the current field.
#273 1:2-45
Select the form to display on the screen in a window beginning at
the current cursor position. Press ESC EXIT to remove the related form.
#274 1:2-46
Select the related form that contains the value you want to look up.
Press RETURN to bring the value from the related form back to the
Primary form.
#275 2:2-130
Select {Yes} to delete the relationship records that use the name of
the form you are deleting.
Select {No} to delete just the form and none of the RELATIONSHIPS form
records.
#277 s 3:6-111 - 3:6-112
{lock} all files ^| filename ^| selected record ^[shared^| exclusive^].
LAN command used to override the default Multi-User Locking Rules
specified on the System Configuration form.
Select {lock all files} to lock all the forms referenced by the
procedure. Select {lock filename} to lock just the specified form.
Select {lock selected records} to lock just the record that is
currently being processed.
The {shared} option lets users view the locked resource. The
{exclusive} option prevents all access to the locked resource.
#278 s 3:6-186 - 3:6-187
{unlock} all files ^| filename ^| selected record .
LAN command used to override the default Multi-User Locking Rules
specified on the System Configuration form. Unlocks resources
specified by a DQL {lock} command.
Select {unlock all files} to unlock all the forms referenced by the
procedure. Select {unlock filename} to unlock just the specified form.
Select {unlock selected records} to unlock just the record that is
currently being processed.
#279 s 3:6-152 - 3:6-153
{query selection} lock files ^| records ^| nothing .
LAN command used to override the default Multi-User Locking Rules
specified on the System Configuration form.
Select {query selection lock files} to lock every form referenced by
the procedure that contains any records selected for processing.
Select {query selection lock records} to lock every record selected for
processing. Select {query selection lock nothing} to lock no forms or
records. This option allows users to view, modify, or delete records
selected for processing by the procedure.
Once the procedure begins actually processing the selected records, the
query selection lock is forfeited.
#280 s 3:6-95 - 3:6-98
{input using} FORMNAME {into} "TEMPFORM" .
Provides record entry functions at any time during the procedure and
processes the input data.
Specify the name of the form that contains the data you want to input.
Specify the name of a second temporary form, enclosed in quotation
marks, to reference the input record.
When the input record is processed, DataEase stores one of the
following values in the current status variable depending on which key
was pressed to input the record: (ESC=1), (F2=2), (F7=3), (F8=4). This
value can be used to control subsequent conditional processing.
#281 s 3:6-139 - 3:6-143
{output}:
FIELD NAME ^| TEXT
.
Writes text or fields directly to the output device while processing
the procedure.
Insert the {output} command followed by a colon in column 1 of the
query. Press F10 FIELD to enter a field or specify the text you want to
appear in the output.
Following the last line to be output, insert a period in column 1 of
the query.
#282 s 3:6-122 - 3:6-123
{message} "MESSAGE TEXT" ^[{window}^] ^[{pause}^] .
Enter the message you want to display enclosed in quotation marks.
The default displays up to a 40-character message in the upper right corner
of the screen. The {window} option displays a message of up to 4,000
characters in a window. The {pause} option requires a user to press a
key to resume processing.
#283 s 3:6-38 - 3:6-39
{case} (EXPRESSION)
{value} COMPARISON 1:
ACTION SERIES 1 .
^[{others}:
OTHERS ACTION SERIES .^]
{end}
Compares expression to a series of values and executes different
action(s) based on which comparison is true.
Insert the {case} command. Specify an expression enclosed in
parentheses and press RETURN. Next, insert the keyword {value}.
Specify a comparison value followed by a colon. After each value
statement, enter the action(s) DataEase should perform if the value
comparison is true. Each action statement is followed by a period.
After the last value-action series, optionally insert the keyword
{others} and specify the action(s) you want DataEase to take if none
of the preceding comparisons are true. The {case} command must be
terminated by an {end} command.
#284 3:6-190
{value} :
ACTION SERIES .
Part of the {case} command that compares an expression to a series of
values and executes different actions based on which comparison is
true.
Specify a value followed by a colon and press RETURN. Then specify the
action(s) you want DataEase to perform if the value comparison is true.
Each action statement is terminated by a period.
#285 3:6-138
{others} :
ACTION SERIES .
Part of the {case} command that compares an expression to a series of
values and executes different actions based on which comparison is
true.
Specify the action(s) you want DataEase to perform if none of the
preceding value comparisons is true. Each action statement is
terminated by a period.
#286 3:6-162
{run procedure} "PROCEDURE NAME" .
Loads and runs the specified procedure.
Enter the name of the procedure enclosed in quotation marks, followed
by a period.
#287 3:6-35
{call menu} "MENU NAME" .
Displays the specified DataEase system or custom defined menu.
Enter the name of the menu enclosed in quotation marks, followed by a
period. If a chain menu is called, it is executed, but not displayed.
#288 3:6-36
{call program} "PROGRAM NAME ^[ARGUMENTS^]" .
Loads and runs the specified program.
Enter the name of the program enclosed in quotation marks, followed by
a period. The program name can be a constant or an expression involving
functions and variables. Specify the full PATH if the program is
not in the current directory.
#289 3:6-156
{record entry} "FORMNAME" .
Displays the specified form, allowing Record Entry functions to be
performed during the procedure.
The input data is entered directly into the database; it is not
processed by the procedure.
#290 3:6-89
{import} "IMPORT SPECIFICATION NAME" .
Imports data into a DataEase form according to a previously defined
import specification.
Enter the name of the import specification enclosed in quotation marks,
followed by a period.
#291 3:6-159
{reorganize} "FORMNAME" .
Reorganizes the specified form; this permanently erases all deleted
records and then recreates all the indexes used to organize the data.
Enter the name of the form enclosed in quotation marks, followed by a
period.
#292 3:6-57
{db status} .
Generates a report that summarizes the status of the forms, procedures,
and/or imports in the current database. The default displays the report on
the screen. Press SH-F9 PRINT to send the report to the printer.
#293 3:6-31
{backup db} .
Creates a backup copy of the current database in a special DataEase
format. The backup must be restored using the {restore db} command or
the [Restore Database] option on the Maintenance menu.
DataEase prompts you for the information and/or disks needed to perform
the backup.
#294 3:6-161
{restore db} .
Restores a database from a backup copy created by the {backup db} command
or the [Backup Database] option on the Maintenance menu.
DataEase prompts you for the information and/or disks needed to perform
the restore.
#295 s 3:6-113 - 3:6-114
{lock db} .
LAN command used to override the default Multi-User Locking Rules
specified on the System Configuration form.
Select {lock db} to lock the current database.
This prohibits any user from signing on to the current database.
#296 3:6-188
{unlock db} .
LAN command used to override the default Multi-User Locking Rules
specified on the System Configuration form.
Select {unlock db} to terminate the {lock db} command and unlock the
current database.
#297 3:6-99
{install appl} "INSTALLATION FILENAME" .
Installs forms, reports, procedures, or entire applications in the
current database.
Enter the name of the installation command file (.DIN filename
extension) enclosed in quotation marks, followed by a period.